Chatbot Dump Report

Type of Report -

Standard

Purpose of the Report -

This report is currently used by Vodafone only.

This report contains 2 worksheets-

i) chatbot dump : The purpose of this worksheet is mainly to fetch the basic details of the customer based on the user’s chatbot journey.

ii) msisdn query : This worksheet contains the information about the number of times a user asks about the query; i.e. it gives the count of each query a user asks in.

Detailed Description -

i) chatbot dump

Name of Column	Description of Field	Where is the value fetched from
startDate	Concat of start date and time of session	startDate (SessionInfo)
phone	Msisdn of customer	'$userInfo.phone_no’(SessionInfo)
group	Customer group	'$userInfo.customerGroup’ (SessionInfo)
brand	Brand name(Vodafone)	$userInfo.company (SessionInfo)
circle	Circle name	calculated codewise based on circleName (SessionInfo)
platform	Platform name from where user enters bot except whatsapp	‘log_info.query.channelName’ (chat_sessions)

ii) msisdn query

Name of Column	Description	Where is the value fetched from
Date	Date when session is created	startDate (SessionInfo)
Phone Number	Msisdn of customer	sessionInfo
Query	Events fired when user asks any faq/query	event_logs
Count	Count of the each query user asks in a day	event_logs

Example of Report -

Report-Link : https://docs.google.com/spreadsheets/d/1dQ8tD76i8xr7hnzM-okWfc0EdcEsF7HCLe9gVZqzdoM/edit?usp=sharing

Report Format -

Branch : development

Path : Reports/chatbotDumpReport.js

Aggregation -

Branch : development

Path : Reports/chatbotDumpReport.js